//
//  StockBrandCategoryJa.h
//  DataCollector
//
//  Created by jiro on 12/06/09.
//  Copyright 2012 jiro music. All rights reserved.
//

#import <Cocoa/Cocoa.h>

#import "DbTableEntry_.h"

class StockBrandCategoryJaType
{
	public:
	enum Type 
	{
		NorinSuisanGyou,
		KouGyou,
		KenSetsu,
		ShokuHin,
		SenniSeiHin,
		ParupuKami,
		KagakuIYakuHin,
		SekiYuSekiTan,
		Gomu,
		YouGyou,
		TeKkou,
		HiTetsuKinZoku,
		KinZokuSeiHin,
		KiKai,
		DenKi,
		YuSouYouKiKai,
		SeiMitsuKiKai,
		SonoTaSeiHin,
		ShouGyou,
		GinKouNonBank,
		ShouKenShouKenSakiMono,
		HoKen,
		HuDouSan,
		RikuUn,
		KaiUn,
		KuuUn,
		SouKoYuSou,
		JouHouTsuuSin,
		DenKiGas,
		Service
	};
};

@interface StockBrandCategoryJa : DbTableEntry_
{
	StockBrandCategoryJaType::Type type;

	NSString* name;

	NSString* startCode;

	NSString* endCode;

}

@property (assign) StockBrandCategoryJaType::Type type;
@property (assign) NSString* name;
@property (assign) NSString* startCode;
@property (assign) NSString* endCode;


+ (NSString*) tableName;

+ (NSString*) queryCreateTable;

- (NSString*) queryInsertValue;

+ (NSString*) queryInsertInitialValues;

//	---- sql query  ---- //
+ (NSString*) querySelectAll;

- (NSString*) queryInsert;
- (NSString*) queryInsertValue;

@end
